Tabela LPatientInsurance

Definicja tabeli LPatientInsurance

Name

LPatientInsurance

Code

LPatientInsurance

Comment

 


Lista kolumn tabeli LPatientInsurance

Name

Code

InsuranceID

InsuranceID

PatientID

PatientID

StartDT

StartDT

StopDT

StopDT


Kolumna InsuranceID tabeli LPatientInsurance

Definicja kolumny InsuranceID tabeli LPatientInsurance

Name

InsuranceID

Code

InsuranceID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna PatientID tabeli LPatientInsurance

Definicja kolumny PatientID tabeli LPatientInsurance

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LPatientInsurance

Definicja kolumny StartDT tabeli LPatientInsurance

Name

StartDT

Code

StartDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna StopDT tabeli LPatientInsurance

Definicja kolumny StopDT tabeli LPatientInsurance

Name

StopDT

Code

StopDT

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Lista kluczy tabeli LPatientInsurance

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LPatientInsurance

Definicja klucza Identifier_1 tabeli LPatientInsurance

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment